Dataset statistics
| Number of variables | 29 |
|---|---|
| Number of observations | 15712 |
| Missing cells | 106947 |
| Missing cells (%) | 23.5% |
| Duplicate rows | 20 |
| Duplicate rows (%) | 0.1% |
| Total size in memory | 22.4 MiB |
| Average record size in memory | 1.5 KiB |
Variable types
| Numeric | 8 |
|---|---|
| DateTime | 5 |
| Categorical | 6 |
| Text | 8 |
| Unsupported | 2 |
Check-out has constant value "2024-08-24 11:00:00" | Constant |
| Dataset has 20 (0.1%) duplicate rows | Duplicates |
Adelanto ya pagado is highly overall correlated with ComisiĂ³n incluida and 2 other fields | High correlation |
Adultos is highly overall correlated with Numero_Huespedes and 2 other fields | High correlation |
Apartamento is highly overall correlated with Pago por adelantado | High correlation |
ComisiĂ³n incluida is highly overall correlated with Adelanto ya pagado and 2 other fields | High correlation |
Estado is highly overall correlated with Pago por adelantado | High correlation |
Niños is highly overall correlated with Pago por adelantado | High correlation |
Numero_Huespedes is highly overall correlated with Adultos and 2 other fields | High correlation |
Numero_Reserva is highly overall correlated with Adelanto ya pagado and 2 other fields | High correlation |
NĂºmero de noches is highly overall correlated with ComisiĂ³n incluida and 2 other fields | High correlation |
Pagado is highly overall correlated with Adultos and 3 other fields | High correlation |
Pago por adelantado is highly overall correlated with Adelanto ya pagado and 9 other fields | High correlation |
Portal de reserva is highly overall correlated with Numero_Reserva and 2 other fields | High correlation |
PosiciĂ³n is highly overall correlated with Numero_Reserva | High correlation |
Precio is highly overall correlated with ComisiĂ³n incluida and 2 other fields | High correlation |
Adelanto ya pagado is highly imbalanced (99.6%) | Imbalance |
Estado is highly imbalanced (67.0%) | Imbalance |
Huésped has 1375 (8.8%) missing values | Missing |
Email has 4803 (30.6%) missing values | Missing |
Teléfono has 2568 (16.3%) missing values | Missing |
DirecciĂ³n has 15712 (100.0%) missing values | Missing |
Check-in has 4759 (30.3%) missing values | Missing |
Check-out has 4857 (30.9%) missing values | Missing |
Notas has 2272 (14.5%) missing values | Missing |
Precio has 1469 (9.3%) missing values | Missing |
Detalles de precios has 3063 (19.5%) missing values | Missing |
ComisiĂ³n incluida has 3075 (19.6%) missing values | Missing |
City tax has 15712 (100.0%) missing values | Missing |
Pago por adelantado has 15708 (> 99.9%) missing values | Missing |
Nota para colaboradores has 15703 (99.9%) missing values | Missing |
Numero_Reserva has 5285 (33.6%) missing values | Missing |
Mensaje_Huesped has 5293 (33.7%) missing values | Missing |
BOOKING_NOTE has 5293 (33.7%) missing values | Missing |
NĂºmero de noches is highly skewed (γ1 = 118.2859681) | Skewed |
DirecciĂ³n is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
City tax is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
Adultos has 2444 (15.6%) zeros | Zeros |
Niños has 12790 (81.4%) zeros | Zeros |
Numero_Huespedes has 2442 (15.5%) zeros | Zeros |
Reproduction
| Analysis started | 2024-08-24 21:42:39.367197 |
|---|---|
| Analysis finished | 2024-08-24 21:45:01.522962 |
| Duration | 2 minutes and 22.16 seconds |
| Software version | ydata-profiling vv4.9.0 |
| Download configuration | config.json |
PosiciĂ³n
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 15692 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 41865996 |
| Minimum | 15390136 |
|---|---|
| Maximum | 69854666 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 122.9 KiB |
Quantile statistics
| Minimum | 15390136 |
|---|---|
| 5-th percentile | 19849936 |
| Q1 | 29516090 |
| median | 41444873 |
| Q3 | 53547937 |
| 95-th percentile | 66463759 |
| Maximum | 69854666 |
| Range | 54464530 |
| Interquartile range (IQR) | 24031847 |
Descriptive statistics
| Standard deviation | 14579774 |
|---|---|
| Coefficient of variation (CV) | 0.3482486 |
| Kurtosis | -1.0654767 |
| Mean | 41865996 |
| Median Absolute Deviation (MAD) | 11998268 |
| Skewness | 0.11885661 |
| Sum | 6.5779852 Ă— 1011 |
| Variance | 2.1256982 Ă— 1014 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 50757695 | 2 | < 0.1% |
| 38091838 | 2 | < 0.1% |
| 31968127 | 2 | < 0.1% |
| 49003082 | 2 | < 0.1% |
| 32169718 | 2 | < 0.1% |
| 49378100 | 2 | < 0.1% |
| 50677661 | 2 | < 0.1% |
| 50878493 | 2 | < 0.1% |
| 50895260 | 2 | < 0.1% |
| 29995319 | 2 | < 0.1% |
| Other values (15682) | 15692 |
| Value | Count | Frequency (%) |
| 15390136 | 1 | |
| 15463501 | 1 | |
| 15776323 | 1 | |
| 15918979 | 1 | |
| 16641582 | 1 | |
| 16811706 | 1 | |
| 16912662 | 1 | |
| 16982857 | 1 | |
| 16993282 | 1 | |
| 16993297 | 1 |
| Value | Count | Frequency (%) |
| 69854666 | 1 | |
| 69849111 | 1 | |
| 69847911 | 1 | |
| 69843366 | 1 | |
| 69840491 | 1 | |
| 69840476 | 1 | |
| 69838566 | 1 | |
| 69834011 | 1 | |
| 69825606 | 1 | |
| 69818721 | 1 |
Llegada
Date
| Distinct | 1024 |
|---|---|
| Distinct (%) | 6.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 122.9 KiB |
| Minimum | 2021-12-19 00:00:00 |
|---|---|
| Maximum | 2024-12-11 00:00:00 |
Salida
Date
| Distinct | 1023 |
|---|---|
| Distinct (%) | 6.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 122.9 KiB |
| Minimum | 2022-01-02 00:00:00 |
|---|---|
| Maximum | 2028-07-31 00:00:00 |
Apartamento
Categorical
HIGH CORRELATION 
| Distinct | 41 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.0 MiB |
| H BMA PRAGA | 734 |
|---|---|
| HD BRUNO | 713 |
| H BMA BERLIN | 710 |
| H - BUA 3P | 697 |
| H - BUA 4P | 685 |
| Other values (36) |
Length
| Max length | 21 |
|---|---|
| Median length | 16 |
| Mean length | 10.908923 |
| Min length | 8 |
Characters and Unicode
| Total characters | 171401 |
|---|---|
| Distinct characters | 33 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | HD OLIVIA |
|---|---|
| 2nd row | HD FIDEL |
| 3rd row | HD ALEJANDRA |
| 4th row | H BMA LISBOA |
| 5th row | HD OLIVIA |
Common Values
| Value | Count | Frequency (%) |
| H BMA PRAGA | 734 | 4.7% |
| HD BRUNO | 713 | 4.5% |
| H BMA BERLIN | 710 | 4.5% |
| H - BUA 3P | 697 | 4.4% |
| H - BUA 4P | 685 | 4.4% |
| HD ELENA | 638 | 4.1% |
| H BMA AMSTERDAM | 637 | 4.1% |
| H BMA MONACO | 625 | 4.0% |
| H BMA OSLO | 623 | 4.0% |
| HD CELESTE | 600 | 3.8% |
| Other values (31) | 9050 |
Length
| Value | Count | Frequency (%) |
| h | 7270 | |
| bma | 5788 | 14.3% |
| hd | 5373 | 13.2% |
| 1482 | 3.7% | |
| bua | 1482 | 3.7% |
| hg0 | 1362 | 3.4% |
| hg1 | 975 | 2.4% |
| praga | 734 | 1.8% |
| bruno | 713 | 1.8% |
| berlin | 710 | 1.7% |
| Other values (41) | 14700 |
Most occurring characters
| Value | Count | Frequency (%) |
| 24877 | ||
| A | 23487 | |
| H | 17721 | 10.3% |
| B | 10659 | 6.2% |
| D | 9603 | 5.6% |
| E | 8425 | 4.9% |
| M | 8323 | 4.9% |
| R | 8219 | 4.8% |
| I | 7818 | 4.6% |
| O | 7197 | 4.2% |
| Other values (23) | 45072 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 171401 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 24877 | ||
| A | 23487 | |
| H | 17721 | 10.3% |
| B | 10659 | 6.2% |
| D | 9603 | 5.6% |
| E | 8425 | 4.9% |
| M | 8323 | 4.9% |
| R | 8219 | 4.8% |
| I | 7818 | 4.6% |
| O | 7197 | 4.2% |
| Other values (23) | 45072 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 171401 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 24877 | ||
| A | 23487 | |
| H | 17721 | 10.3% |
| B | 10659 | 6.2% |
| D | 9603 | 5.6% |
| E | 8425 | 4.9% |
| M | 8323 | 4.9% |
| R | 8219 | 4.8% |
| I | 7818 | 4.6% |
| O | 7197 | 4.2% |
| Other values (23) | 45072 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 171401 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 24877 | ||
| A | 23487 | |
| H | 17721 | 10.3% |
| B | 10659 | 6.2% |
| D | 9603 | 5.6% |
| E | 8425 | 4.9% |
| M | 8323 | 4.9% |
| R | 8219 | 4.8% |
| I | 7818 | 4.6% |
| O | 7197 | 4.2% |
| Other values (23) | 45072 |
Huésped
Text
MISSING 
| Distinct | 12201 |
|---|---|
| Distinct (%) | 85.1% |
| Missing | 1375 |
| Missing (%) | 8.8% |
| Memory size | 1.2 MiB |
Length
| Max length | 127 |
|---|---|
| Median length | 63 |
| Mean length | 16.398131 |
| Min length | 1 |
Characters and Unicode
| Total characters | 235100 |
|---|---|
| Distinct characters | 241 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 11300 ? |
|---|---|
| Unique (%) | 78.8% |
Sample
| 1st row | Leticia Isla |
|---|---|
| 2nd row | Rodri Gamboa |
| 3rd row | luis |
| 4th row | NATHAN benony |
| 5th row | Dario |
| Value | Count | Frequency (%) |
| de | 338 | 1.0% |
| maria | 307 | 0.9% |
| garcia | 256 | 0.7% |
| jose | 229 | 0.7% |
| rodriguez | 180 | 0.5% |
| juan | 172 | 0.5% |
| javier | 159 | 0.5% |
| martinez | 154 | 0.4% |
| ana | 153 | 0.4% |
| amplio | 153 | 0.4% |
| Other values (12026) | 32730 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 26695 | 11.4% |
| 20561 | 8.7% | |
| e | 18914 | 8.0% |
| r | 16109 | 6.9% |
| i | 14381 | 6.1% |
| o | 13819 | 5.9% |
| n | 13444 | 5.7% |
| l | 10297 | 4.4% |
| s | 7222 | 3.1% |
| t | 5901 | 2.5% |
| Other values (231) | 87757 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 235100 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 26695 | 11.4% |
| 20561 | 8.7% | |
| e | 18914 | 8.0% |
| r | 16109 | 6.9% |
| i | 14381 | 6.1% |
| o | 13819 | 5.9% |
| n | 13444 | 5.7% |
| l | 10297 | 4.4% |
| s | 7222 | 3.1% |
| t | 5901 | 2.5% |
| Other values (231) | 87757 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 235100 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 26695 | 11.4% |
| 20561 | 8.7% | |
| e | 18914 | 8.0% |
| r | 16109 | 6.9% |
| i | 14381 | 6.1% |
| o | 13819 | 5.9% |
| n | 13444 | 5.7% |
| l | 10297 | 4.4% |
| s | 7222 | 3.1% |
| t | 5901 | 2.5% |
| Other values (231) | 87757 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 235100 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 26695 | 11.4% |
| 20561 | 8.7% | |
| e | 18914 | 8.0% |
| r | 16109 | 6.9% |
| i | 14381 | 6.1% |
| o | 13819 | 5.9% |
| n | 13444 | 5.7% |
| l | 10297 | 4.4% |
| s | 7222 | 3.1% |
| t | 5901 | 2.5% |
| Other values (231) | 87757 |
Portal de reserva
Categorical
HIGH CORRELATION 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.0 MiB |
| Booking.com | |
|---|---|
| Airbnb | |
| Reserva directa | |
| Cerrar fechas (bloqueo) | |
| PĂ¡gina web | 305 |
Length
| Max length | 23 |
|---|---|
| Median length | 11 |
| Mean length | 11.647149 |
| Min length | 6 |
Characters and Unicode
| Total characters | 183000 |
|---|---|
| Distinct characters | 31 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Cerrar fechas (bloqueo) |
|---|---|
| 2nd row | Cerrar fechas (bloqueo) |
| 3rd row | Cerrar fechas (bloqueo) |
| 4th row | Cerrar fechas (bloqueo) |
| 5th row | Cerrar fechas (bloqueo) |
Common Values
| Value | Count | Frequency (%) |
| Booking.com | 10439 | |
| Airbnb | 2223 | 14.1% |
| Reserva directa | 1419 | 9.0% |
| Cerrar fechas (bloqueo) | 1326 | 8.4% |
| PĂ¡gina web | 305 | 1.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| booking.com | 10439 | |
| airbnb | 2223 | 11.1% |
| reserva | 1419 | 7.1% |
| directa | 1419 | 7.1% |
| cerrar | 1326 | 6.6% |
| fechas | 1326 | 6.6% |
| bloqueo | 1326 | 6.6% |
| pĂ¡gina | 305 | 1.5% |
| web | 305 | 1.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 33969 | |
| i | 14386 | 7.9% |
| c | 13184 | 7.2% |
| n | 12967 | 7.1% |
| g | 10744 | 5.9% |
| B | 10439 | 5.7% |
| k | 10439 | 5.7% |
| . | 10439 | 5.7% |
| m | 10439 | 5.7% |
| r | 9039 | 4.9% |
| Other values (21) | 46955 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 183000 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 33969 | |
| i | 14386 | 7.9% |
| c | 13184 | 7.2% |
| n | 12967 | 7.1% |
| g | 10744 | 5.9% |
| B | 10439 | 5.7% |
| k | 10439 | 5.7% |
| . | 10439 | 5.7% |
| m | 10439 | 5.7% |
| r | 9039 | 4.9% |
| Other values (21) | 46955 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 183000 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 33969 | |
| i | 14386 | 7.9% |
| c | 13184 | 7.2% |
| n | 12967 | 7.1% |
| g | 10744 | 5.9% |
| B | 10439 | 5.7% |
| k | 10439 | 5.7% |
| . | 10439 | 5.7% |
| m | 10439 | 5.7% |
| r | 9039 | 4.9% |
| Other values (21) | 46955 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 183000 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 33969 | |
| i | 14386 | 7.9% |
| c | 13184 | 7.2% |
| n | 12967 | 7.1% |
| g | 10744 | 5.9% |
| B | 10439 | 5.7% |
| k | 10439 | 5.7% |
| . | 10439 | 5.7% |
| m | 10439 | 5.7% |
| r | 9039 | 4.9% |
| Other values (21) | 46955 |
Creado
Date
| Distinct | 14803 |
|---|---|
| Distinct (%) | 94.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 122.9 KiB |
| Minimum | 2021-02-12 11:22:00 |
|---|---|
| Maximum | 2024-12-08 23:16:00 |
Email
Text
MISSING 
| Distinct | 10373 |
|---|---|
| Distinct (%) | 95.1% |
| Missing | 4803 |
| Missing (%) | 30.6% |
| Memory size | 1.1 MiB |
Length
| Max length | 40 |
|---|---|
| Median length | 31 |
| Mean length | 30.558988 |
| Min length | 12 |
Characters and Unicode
| Total characters | 333368 |
|---|---|
| Distinct characters | 62 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 10008 ? |
|---|---|
| Unique (%) | 91.7% |
Sample
| 1st row | lisla.593122@guest.booking.com |
|---|---|
| 2nd row | rgambo.386041@guest.booking.com |
| 3rd row | nbenon.480362@guest.booking.com |
| 4th row | aaquit.901533@guest.booking.com |
| 5th row | hlee.108965@guest.booking.com |
| Value | Count | Frequency (%) |
| marycasadocarreto@gmail.com | 13 | 0.1% |
| officialbryan09@aol.com | 12 | 0.1% |
| institucional@castellersdevilafranca.cat | 10 | 0.1% |
| carabalil@aol.com | 10 | 0.1% |
| jvila.937171@guest.booking.com | 8 | 0.1% |
| lsanz@paulmitchell.es | 8 | 0.1% |
| yaling0404068@gmail.com | 7 | 0.1% |
| ksaman.612410@guest.booking.com | 6 | 0.1% |
| juanjomaruno@gmail.com | 6 | 0.1% |
| jm.barquin@protiopower.com | 6 | 0.1% |
| Other values (10362) | 10823 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 36144 | 10.8% |
| . | 31987 | 9.6% |
| g | 23229 | 7.0% |
| e | 16231 | 4.9% |
| i | 15104 | 4.5% |
| m | 14642 | 4.4% |
| n | 14067 | 4.2% |
| s | 13868 | 4.2% |
| c | 13815 | 4.1% |
| t | 12751 | 3.8% |
| Other values (52) | 141530 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 333368 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 36144 | 10.8% |
| . | 31987 | 9.6% |
| g | 23229 | 7.0% |
| e | 16231 | 4.9% |
| i | 15104 | 4.5% |
| m | 14642 | 4.4% |
| n | 14067 | 4.2% |
| s | 13868 | 4.2% |
| c | 13815 | 4.1% |
| t | 12751 | 3.8% |
| Other values (52) | 141530 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 333368 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 36144 | 10.8% |
| . | 31987 | 9.6% |
| g | 23229 | 7.0% |
| e | 16231 | 4.9% |
| i | 15104 | 4.5% |
| m | 14642 | 4.4% |
| n | 14067 | 4.2% |
| s | 13868 | 4.2% |
| c | 13815 | 4.1% |
| t | 12751 | 3.8% |
| Other values (52) | 141530 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 333368 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 36144 | 10.8% |
| . | 31987 | 9.6% |
| g | 23229 | 7.0% |
| e | 16231 | 4.9% |
| i | 15104 | 4.5% |
| m | 14642 | 4.4% |
| n | 14067 | 4.2% |
| s | 13868 | 4.2% |
| c | 13815 | 4.1% |
| t | 12751 | 3.8% |
| Other values (52) | 141530 |
Teléfono
Text
MISSING 
| Distinct | 11601 |
|---|---|
| Distinct (%) | 88.3% |
| Missing | 2568 |
| Missing (%) | 16.3% |
| Memory size | 1000.4 KiB |
Length
| Max length | 20 |
|---|---|
| Median length | 16 |
| Mean length | 14.67605 |
| Min length | 9 |
Characters and Unicode
| Total characters | 192902 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 10713 ? |
|---|---|
| Unique (%) | 81.5% |
Sample
| 1st row | +34 656 73 69 43 |
|---|---|
| 2nd row | +34 662 96 91 70 |
| 3rd row | +33 6 17 12 54 98 |
| 4th row | +34 670 90 62 94 |
| 5th row | +82 421915930214 |
| Value | Count | Frequency (%) |
| 34 | 7159 | 14.6% |
| 33 | 1126 | 2.3% |
| 6 | 928 | 1.9% |
| 49 | 525 | 1.1% |
| 31 | 510 | 1.0% |
| 39 | 505 | 1.0% |
| 44 | 499 | 1.0% |
| 32 | 331 | 0.7% |
| 70 | 315 | 0.6% |
| 48 | 309 | 0.6% |
| Other values (6138) | 36907 |
Most occurring characters
| Value | Count | Frequency (%) |
| 35972 | ||
| 3 | 23286 | |
| 6 | 21280 | |
| 4 | 20387 | |
| 7 | 12564 | 6.5% |
| 1 | 12028 | 6.2% |
| 9 | 11926 | 6.2% |
| 5 | 11833 | 6.1% |
| 2 | 11328 | 5.9% |
| 0 | 11082 | 5.7% |
| Other values (2) | 21216 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 192902 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 35972 | ||
| 3 | 23286 | |
| 6 | 21280 | |
| 4 | 20387 | |
| 7 | 12564 | 6.5% |
| 1 | 12028 | 6.2% |
| 9 | 11926 | 6.2% |
| 5 | 11833 | 6.1% |
| 2 | 11328 | 5.9% |
| 0 | 11082 | 5.7% |
| Other values (2) | 21216 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 192902 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 35972 | ||
| 3 | 23286 | |
| 6 | 21280 | |
| 4 | 20387 | |
| 7 | 12564 | 6.5% |
| 1 | 12028 | 6.2% |
| 9 | 11926 | 6.2% |
| 5 | 11833 | 6.1% |
| 2 | 11328 | 5.9% |
| 0 | 11082 | 5.7% |
| Other values (2) | 21216 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 192902 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 35972 | ||
| 3 | 23286 | |
| 6 | 21280 | |
| 4 | 20387 | |
| 7 | 12564 | 6.5% |
| 1 | 12028 | 6.2% |
| 9 | 11926 | 6.2% |
| 5 | 11833 | 6.1% |
| 2 | 11328 | 5.9% |
| 0 | 11082 | 5.7% |
| Other values (2) | 21216 |
DirecciĂ³n
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 15712 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 122.9 KiB |
Adultos
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 9 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.2334521 |
| Minimum | 0 |
|---|---|
| Maximum | 8 |
| Zeros | 2444 |
| Zeros (%) | 15.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 122.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 5 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.5834759 |
|---|---|
| Coefficient of variation (CV) | 0.70898135 |
| Kurtosis | 0.89371826 |
| Mean | 2.2334521 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.78889935 |
| Sum | 35092 |
| Variance | 2.5073959 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 6114 | |
| 0 | 2444 | 15.6% |
| 3 | 2098 | 13.4% |
| 1 | 1958 | 12.5% |
| 4 | 1903 | 12.1% |
| 5 | 528 | 3.4% |
| 6 | 389 | 2.5% |
| 7 | 198 | 1.3% |
| 8 | 80 | 0.5% |
| Value | Count | Frequency (%) |
| 0 | 2444 | 15.6% |
| 1 | 1958 | 12.5% |
| 2 | 6114 | |
| 3 | 2098 | 13.4% |
| 4 | 1903 | 12.1% |
| 5 | 528 | 3.4% |
| 6 | 389 | 2.5% |
| 7 | 198 | 1.3% |
| 8 | 80 | 0.5% |
| Value | Count | Frequency (%) |
| 8 | 80 | 0.5% |
| 7 | 198 | 1.3% |
| 6 | 389 | 2.5% |
| 5 | 528 | 3.4% |
| 4 | 1903 | 12.1% |
| 3 | 2098 | 13.4% |
| 2 | 6114 | |
| 1 | 1958 | 12.5% |
| 0 | 2444 | 15.6% |
Niños
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.32764766 |
| Minimum | 0 |
|---|---|
| Maximum | 7 |
| Zeros | 12790 |
| Zeros (%) | 81.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 122.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 2 |
| Maximum | 7 |
| Range | 7 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.75253459 |
|---|---|
| Coefficient of variation (CV) | 2.29678 |
| Kurtosis | 5.4976049 |
| Mean | 0.32764766 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.3708238 |
| Sum | 5148 |
| Variance | 0.56630831 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 12790 | |
| 2 | 1503 | 9.6% |
| 1 | 1093 | 7.0% |
| 3 | 272 | 1.7% |
| 4 | 43 | 0.3% |
| 5 | 6 | < 0.1% |
| 6 | 4 | < 0.1% |
| 7 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 12790 | |
| 1 | 1093 | 7.0% |
| 2 | 1503 | 9.6% |
| 3 | 272 | 1.7% |
| 4 | 43 | 0.3% |
| 5 | 6 | < 0.1% |
| 6 | 4 | < 0.1% |
| 7 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 7 | 1 | < 0.1% |
| 6 | 4 | < 0.1% |
| 5 | 6 | < 0.1% |
| 4 | 43 | 0.3% |
| 3 | 272 | 1.7% |
| 2 | 1503 | 9.6% |
| 1 | 1093 | 7.0% |
| 0 | 12790 |
Check-in
Date
MISSING 
| Distinct | 16 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 4759 |
| Missing (%) | 30.3% |
| Memory size | 122.9 KiB |
| Minimum | 2024-08-24 00:00:00 |
|---|---|
| Maximum | 2024-08-24 23:30:00 |
Check-out
Date
CONSTANT  MISSING 
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 4857 |
| Missing (%) | 30.9% |
| Memory size | 122.9 KiB |
| Minimum | 2024-08-24 11:00:00 |
|---|---|
| Maximum | 2024-08-24 11:00:00 |
Notas
Text
MISSING 
| Distinct | 12902 |
|---|---|
| Distinct (%) | 96.0% |
| Missing | 2272 |
| Missing (%) | 14.5% |
| Memory size | 7.5 MiB |
Length
| Max length | 1115 |
|---|---|
| Median length | 921 |
| Mean length | 246.22515 |
| Min length | 3 |
Characters and Unicode
| Total characters | 3309266 |
|---|---|
| Distinct characters | 271 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 12529 ? |
|---|---|
| Unique (%) | 93.2% |
Sample
| 1st row | NĂºmero de reserva: 3509184945 Mensaje del huĂ©sped: ** THIS RESERVATION HAS BEEN PRE-PAID ** BOOKING NOTE : Payment charge is EUR 2.5839 MĂ¡s informaciĂ³n: booker_is_genius Pago por adelantado: 234.90EUR |
|---|---|
| 2nd row | NĂºmero de reserva: 3677697588 Mensaje del huĂ©sped: ** THIS RESERVATION HAS BEEN PRE-PAID ** Approximate time of arrival: between 14:00 and 15:00 BOOKING NOTE : Payment charge is EUR 1.045 MĂ¡s informaciĂ³n: booker_is_genius Pago por adelantado: 95.00EUR |
| 3rd row | NĂºmero de reserva: 2331981900 Mensaje del huĂ©sped: ** THIS RESERVATION HAS BEEN PRE-PAID ** Approximate time of arrival: between 17:00 and 18:00 BOOKING NOTE : Payment charge is EUR 2.695 MĂ¡s informaciĂ³n: booker_is_genius Pago por adelantado: 245.00EUR |
| 4th row | Trjeta 28.12 |
| 5th row | NĂºmero de reserva: 3390950867 Mensaje del huĂ©sped: ** THIS RESERVATION HAS BEEN PRE-PAID ** BOOKING NOTE : Payment charge is EUR 2.211 MĂ¡s informaciĂ³n: booker_is_genius Pago por adelantado: 201.00EUR |
| Value | Count | Frequency (%) |
| 33710 | 7.4% | |
| de | 15271 | 3.3% |
| reserva | 14363 | 3.1% |
| del | 14235 | 3.1% |
| nĂºmero | 12662 | 2.8% |
| huésped | 12634 | 2.8% |
| por | 11125 | 2.4% |
| mĂ¡s | 10652 | 2.3% |
| has | 10649 | 2.3% |
| is | 10619 | 2.3% |
| Other values (26638) | 310910 |
Most occurring characters
| Value | Count | Frequency (%) |
| 395960 | 12.0% | |
| e | 239121 | 7.2% |
| a | 181972 | 5.5% |
| o | 132880 | 4.0% |
| r | 127744 | 3.9% |
| n | 122691 | 3.7% |
| s | 120443 | 3.6% |
| i | 114242 | 3.5% |
| d | 91393 | 2.8% |
| E | 86974 | 2.6% |
| Other values (261) | 1695846 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 3309266 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 395960 | 12.0% | |
| e | 239121 | 7.2% |
| a | 181972 | 5.5% |
| o | 132880 | 4.0% |
| r | 127744 | 3.9% |
| n | 122691 | 3.7% |
| s | 120443 | 3.6% |
| i | 114242 | 3.5% |
| d | 91393 | 2.8% |
| E | 86974 | 2.6% |
| Other values (261) | 1695846 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 3309266 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 395960 | 12.0% | |
| e | 239121 | 7.2% |
| a | 181972 | 5.5% |
| o | 132880 | 4.0% |
| r | 127744 | 3.9% |
| n | 122691 | 3.7% |
| s | 120443 | 3.6% |
| i | 114242 | 3.5% |
| d | 91393 | 2.8% |
| E | 86974 | 2.6% |
| Other values (261) | 1695846 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 3309266 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 395960 | 12.0% | |
| e | 239121 | 7.2% |
| a | 181972 | 5.5% |
| o | 132880 | 4.0% |
| r | 127744 | 3.9% |
| n | 122691 | 3.7% |
| s | 120443 | 3.6% |
| i | 114242 | 3.5% |
| d | 91393 | 2.8% |
| E | 86974 | 2.6% |
| Other values (261) | 1695846 |
Precio
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 2520 |
|---|---|
| Distinct (%) | 17.7% |
| Missing | 1469 |
| Missing (%) | 9.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 230.485 |
| Minimum | 1.15 |
|---|---|
| Maximum | 7847.6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 122.9 KiB |
Quantile statistics
| Minimum | 1.15 |
|---|---|
| 5-th percentile | 45 |
| Q1 | 81.95 |
| median | 148 |
| Q3 | 272 |
| 95-th percentile | 674 |
| Maximum | 7847.6 |
| Range | 7846.45 |
| Interquartile range (IQR) | 190.05 |
Descriptive statistics
| Standard deviation | 292.40293 |
|---|---|
| Coefficient of variation (CV) | 1.2686419 |
| Kurtosis | 129.08129 |
| Mean | 230.485 |
| Median Absolute Deviation (MAD) | 77 |
| Skewness | 7.743219 |
| Sum | 3282797.8 |
| Variance | 85499.472 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 65 | 280 | 1.8% |
| 20 | 259 | 1.6% |
| 71 | 220 | 1.4% |
| 77 | 206 | 1.3% |
| 59 | 163 | 1.0% |
| 83 | 155 | 1.0% |
| 60 | 141 | 0.9% |
| 53.1 | 135 | 0.9% |
| 40 | 132 | 0.8% |
| 95 | 128 | 0.8% |
| Other values (2510) | 12424 | |
| (Missing) | 1469 | 9.3% |
| Value | Count | Frequency (%) |
| 1.15 | 1 | < 0.1% |
| 2.25 | 1 | < 0.1% |
| 3 | 1 | < 0.1% |
| 8.91 | 1 | < 0.1% |
| 10 | 27 | |
| 11 | 1 | < 0.1% |
| 13 | 1 | < 0.1% |
| 13.5 | 1 | < 0.1% |
| 15 | 25 | |
| 17.25 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 7847.6 | 2 | |
| 7330 | 1 | |
| 5785 | 1 | |
| 5595.25 | 1 | |
| 4097 | 1 | |
| 3886 | 1 | |
| 3800 | 1 | |
| 3738.2 | 1 | |
| 3630 | 1 | |
| 3600 | 1 |
MISSING 
| Distinct | 3735 |
|---|---|
| Distinct (%) | 29.5% |
| Missing | 3063 |
| Missing (%) | 19.5% |
| Memory size | 1.1 MiB |
Length
| Max length | 183 |
|---|---|
| Median length | 123 |
| Mean length | 26.488971 |
| Min length | 11 |
Characters and Unicode
| Total characters | 335059 |
|---|---|
| Distinct characters | 40 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2083 ? |
|---|---|
| Unique (%) | 16.5% |
Sample
| 1st row | TVA - EUR 21.35 |
|---|---|
| 2nd row | TVA - EUR 8.64 |
| 3rd row | TVA - EUR 22.27 |
| 4th row | IVA - EUR 18.27 |
| 5th row | TVA - EUR 20.27 |
| Value | Count | Frequency (%) |
| 16463 | ||
| eur | 16463 | |
| iva | 5329 | 7.2% |
| tva | 5097 | 6.9% |
| cancellation | 4448 | 6.0% |
| fee | 2224 | 3.0% |
| host | 2224 | 3.0% |
| payout | 2224 | 3.0% |
| security | 1585 | 2.1% |
| price | 1585 | 2.1% |
| Other values (2963) | 16475 |
Most occurring characters
| Value | Count | Frequency (%) |
| 57654 | 17.2% | |
| - | 16463 | 4.9% |
| E | 16463 | 4.9% |
| U | 16463 | 4.9% |
| R | 16463 | 4.9% |
| . | 13870 | 4.1% |
| e | 12066 | 3.6% |
| a | 11128 | 3.3% |
| 1 | 10765 | 3.2% |
| t | 10489 | 3.1% |
| Other values (30) | 153235 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 335059 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 57654 | 17.2% | |
| - | 16463 | 4.9% |
| E | 16463 | 4.9% |
| U | 16463 | 4.9% |
| R | 16463 | 4.9% |
| . | 13870 | 4.1% |
| e | 12066 | 3.6% |
| a | 11128 | 3.3% |
| 1 | 10765 | 3.2% |
| t | 10489 | 3.1% |
| Other values (30) | 153235 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 335059 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 57654 | 17.2% | |
| - | 16463 | 4.9% |
| E | 16463 | 4.9% |
| U | 16463 | 4.9% |
| R | 16463 | 4.9% |
| . | 13870 | 4.1% |
| e | 12066 | 3.6% |
| a | 11128 | 3.3% |
| 1 | 10765 | 3.2% |
| t | 10489 | 3.1% |
| Other values (30) | 153235 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 335059 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 57654 | 17.2% | |
| - | 16463 | 4.9% |
| E | 16463 | 4.9% |
| U | 16463 | 4.9% |
| R | 16463 | 4.9% |
| . | 13870 | 4.1% |
| e | 12066 | 3.6% |
| a | 11128 | 3.3% |
| 1 | 10765 | 3.2% |
| t | 10489 | 3.1% |
| Other values (30) | 153235 |
ComisiĂ³n incluida
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 2229 |
|---|---|
| Distinct (%) | 17.6% |
| Missing | 3075 |
| Missing (%) | 19.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 35.101689 |
| Minimum | 0.17 |
|---|---|
| Maximum | 867.75 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 122.9 KiB |
Quantile statistics
| Minimum | 0.17 |
|---|---|
| 5-th percentile | 8.1 |
| Q1 | 13.35 |
| median | 23.1 |
| Q3 | 42.04 |
| 95-th percentile | 99.9 |
| Maximum | 867.75 |
| Range | 867.58 |
| Interquartile range (IQR) | 28.69 |
Descriptive statistics
| Standard deviation | 38.59222 |
|---|---|
| Coefficient of variation (CV) | 1.0994406 |
| Kurtosis | 60.283014 |
| Mean | 35.101689 |
| Median Absolute Deviation (MAD) | 11.55 |
| Skewness | 5.3086587 |
| Sum | 443580.04 |
| Variance | 1489.3595 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9.75 | 264 | 1.7% |
| 10.65 | 224 | 1.4% |
| 11.55 | 197 | 1.3% |
| 12.45 | 162 | 1.0% |
| 8.85 | 160 | 1.0% |
| 7.96 | 135 | 0.9% |
| 21.3 | 126 | 0.8% |
| 14.25 | 125 | 0.8% |
| 8.78 | 122 | 0.8% |
| 17.55 | 111 | 0.7% |
| Other values (2219) | 11011 | |
| (Missing) | 3075 | 19.6% |
| Value | Count | Frequency (%) |
| 0.17 | 1 | |
| 0.34 | 1 | |
| 0.45 | 1 | |
| 1.34 | 1 | |
| 1.5 | 1 | |
| 1.65 | 1 | |
| 1.95 | 1 | |
| 2.02 | 1 | |
| 2.25 | 1 | |
| 2.59 | 1 |
| Value | Count | Frequency (%) |
| 867.75 | 1 | |
| 839.29 | 1 | |
| 614.55 | 1 | |
| 582.9 | 1 | |
| 560.73 | 1 | |
| 502.95 | 1 | |
| 492 | 1 | |
| 457.5 | 2 | |
| 445.45 | 1 | |
| 443.27 | 1 |
City tax
Unsupported
MISSING  REJECTED  UNSUPPORTED 
| Missing | 15712 |
|---|---|
| Missing (%) | 100.0% |
| Memory size | 122.9 KiB |
Pagado
Categorical
HIGH CORRELATION 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.2 MiB |
| SĂ | |
|---|---|
| No |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 31424 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | No |
|---|---|
| 2nd row | No |
| 3rd row | No |
| 4th row | No |
| 5th row | No |
Common Values
| Value | Count | Frequency (%) |
| SĂ | 11501 | |
| No | 4211 | 26.8% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| sĂ | 11501 | |
| no | 4211 | 26.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 11501 | |
| Ă | 11501 | |
| N | 4211 | 13.4% |
| o | 4211 | 13.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 31424 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| S | 11501 | |
| Ă | 11501 | |
| N | 4211 | 13.4% |
| o | 4211 | 13.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 31424 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| S | 11501 | |
| Ă | 11501 | |
| N | 4211 | 13.4% |
| o | 4211 | 13.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 31424 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| S | 11501 | |
| Ă | 11501 | |
| N | 4211 | 13.4% |
| o | 4211 | 13.4% |
Pago por adelantado
Categorical
HIGH CORRELATION  MISSING 
| Distinct | 3 |
|---|---|
| Distinct (%) | 75.0% |
| Missing | 15708 |
| Missing (%) | > 99.9% |
| Memory size | 859.4 KiB |
| 40.0 | |
|---|---|
| 800.0 | |
| 140.0 |
Length
| Max length | 5 |
|---|---|
| Median length | 4.5 |
| Mean length | 4.5 |
| Min length | 4 |
Characters and Unicode
| Total characters | 18 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | 50.0% |
Sample
| 1st row | 40.0 |
|---|---|
| 2nd row | 800.0 |
| 3rd row | 40.0 |
| 4th row | 140.0 |
Common Values
| Value | Count | Frequency (%) |
| 40.0 | 2 | < 0.1% |
| 800.0 | 1 | < 0.1% |
| 140.0 | 1 | < 0.1% |
| (Missing) | 15708 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 40.0 | 2 | |
| 800.0 | 1 | |
| 140.0 | 1 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 9 | |
| . | 4 | |
| 4 | 3 | 16.7% |
| 8 | 1 | 5.6% |
| 1 | 1 | 5.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 18 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 9 | |
| . | 4 | |
| 4 | 3 | 16.7% |
| 8 | 1 | 5.6% |
| 1 | 1 | 5.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 18 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 9 | |
| . | 4 | |
| 4 | 3 | 16.7% |
| 8 | 1 | 5.6% |
| 1 | 1 | 5.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 18 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 9 | |
| . | 4 | |
| 4 | 3 | 16.7% |
| 8 | 1 | 5.6% |
| 1 | 1 | 5.6% |
Adelanto ya pagado
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 905.5 KiB |
| No | |
|---|---|
| SĂ | 5 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 31424 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | No |
|---|---|
| 2nd row | No |
| 3rd row | No |
| 4th row | No |
| 5th row | No |
Common Values
| Value | Count | Frequency (%) |
| No | 15707 | |
| SĂ | 5 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| no | 15707 | |
| sĂ | 5 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 15707 | |
| o | 15707 | |
| S | 5 | < 0.1% |
| Ă | 5 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 31424 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| N | 15707 | |
| o | 15707 | |
| S | 5 | < 0.1% |
| Ă | 5 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 31424 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| N | 15707 | |
| o | 15707 | |
| S | 5 | < 0.1% |
| Ă | 5 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 31424 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| N | 15707 | |
| o | 15707 | |
| S | 5 | < 0.1% |
| Ă | 5 | < 0.1% |
NĂºmero de noches
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 37 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.9168152 |
| Minimum | 1 |
|---|---|
| Maximum | 1491 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 122.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 1491 |
| Range | 1490 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 12.117033 |
|---|---|
| Coefficient of variation (CV) | 6.3214407 |
| Kurtosis | 14520.764 |
| Mean | 1.9168152 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 118.28597 |
| Sum | 30117 |
| Variance | 146.8225 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 9425 | |
| 2 | 3572 | 22.7% |
| 3 | 1482 | 9.4% |
| 4 | 663 | 4.2% |
| 5 | 270 | 1.7% |
| 7 | 80 | 0.5% |
| 6 | 78 | 0.5% |
| 8 | 26 | 0.2% |
| 9 | 13 | 0.1% |
| 10 | 13 | 0.1% |
| Other values (27) | 90 | 0.6% |
| Value | Count | Frequency (%) |
| 1 | 9425 | |
| 2 | 3572 | 22.7% |
| 3 | 1482 | 9.4% |
| 4 | 663 | 4.2% |
| 5 | 270 | 1.7% |
| 6 | 78 | 0.5% |
| 7 | 80 | 0.5% |
| 8 | 26 | 0.2% |
| 9 | 13 | 0.1% |
| 10 | 13 | 0.1% |
| Value | Count | Frequency (%) |
| 1491 | 1 | < 0.1% |
| 112 | 1 | < 0.1% |
| 91 | 1 | < 0.1% |
| 81 | 1 | < 0.1% |
| 62 | 2 | < 0.1% |
| 42 | 1 | < 0.1% |
| 40 | 2 | < 0.1% |
| 33 | 1 | < 0.1% |
| 31 | 10 | |
| 30 | 6 |
Estado
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1012.8 KiB |
| Reservado | |
|---|---|
| Cancelado | |
| Overbooking | 15 |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 9.0019094 |
| Min length | 9 |
Characters and Unicode
| Total characters | 141438 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Reservado |
|---|---|
| 2nd row | Reservado |
| 3rd row | Reservado |
| 4th row | Reservado |
| 5th row | Reservado |
Common Values
| Value | Count | Frequency (%) |
| Reservado | 13902 | |
| Cancelado | 1795 | 11.4% |
| Overbooking | 15 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| reservado | 13902 | |
| cancelado | 1795 | 11.4% |
| overbooking | 15 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 29614 | |
| a | 17492 | |
| o | 15727 | |
| d | 15697 | |
| r | 13917 | |
| v | 13917 | |
| R | 13902 | |
| s | 13902 | |
| n | 1810 | 1.3% |
| l | 1795 | 1.3% |
| Other values (7) | 3665 | 2.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 141438 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 29614 | |
| a | 17492 | |
| o | 15727 | |
| d | 15697 | |
| r | 13917 | |
| v | 13917 | |
| R | 13902 | |
| s | 13902 | |
| n | 1810 | 1.3% |
| l | 1795 | 1.3% |
| Other values (7) | 3665 | 2.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 141438 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 29614 | |
| a | 17492 | |
| o | 15727 | |
| d | 15697 | |
| r | 13917 | |
| v | 13917 | |
| R | 13902 | |
| s | 13902 | |
| n | 1810 | 1.3% |
| l | 1795 | 1.3% |
| Other values (7) | 3665 | 2.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 141438 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 29614 | |
| a | 17492 | |
| o | 15727 | |
| d | 15697 | |
| r | 13917 | |
| v | 13917 | |
| R | 13902 | |
| s | 13902 | |
| n | 1810 | 1.3% |
| l | 1795 | 1.3% |
| Other values (7) | 3665 | 2.6% |
MISSING 
| Distinct | 9 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 15703 |
| Missing (%) | 99.9% |
| Memory size | 491.7 KiB |
Length
| Max length | 51 |
|---|---|
| Median length | 31 |
| Mean length | 22.333333 |
| Min length | 13 |
Characters and Unicode
| Total characters | 201 |
|---|---|
| Distinct characters | 38 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 9 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | Tarjeta el 10 |
|---|---|
| 2nd row | Pagado con tarjeta 07-06 |
| 3rd row | Reserva hostel navarra adentro |
| 4th row | pagado por tarjeta |
| 5th row | deja a la salida los 45€ registrar su DNI en chekin |
| Value | Count | Frequency (%) |
| tarjeta | 7 | |
| el | 5 | 13.5% |
| pagado | 2 | 5.4% |
| salida | 1 | 2.7% |
| 28-07 | 1 | 2.7% |
| 27-09 | 1 | 2.7% |
| 02-10 | 1 | 2.7% |
| chekin | 1 | 2.7% |
| en | 1 | 2.7% |
| dni | 1 | 2.7% |
| Other values (16) | 16 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 29 | |
| 28 | ||
| e | 20 | 10.0% |
| r | 15 | 7.5% |
| t | 13 | 6.5% |
| l | 9 | 4.5% |
| j | 8 | 4.0% |
| 0 | 8 | 4.0% |
| o | 7 | 3.5% |
| s | 6 | 3.0% |
| Other values (28) | 58 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 201 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 29 | |
| 28 | ||
| e | 20 | 10.0% |
| r | 15 | 7.5% |
| t | 13 | 6.5% |
| l | 9 | 4.5% |
| j | 8 | 4.0% |
| 0 | 8 | 4.0% |
| o | 7 | 3.5% |
| s | 6 | 3.0% |
| Other values (28) | 58 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 201 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 29 | |
| 28 | ||
| e | 20 | 10.0% |
| r | 15 | 7.5% |
| t | 13 | 6.5% |
| l | 9 | 4.5% |
| j | 8 | 4.0% |
| 0 | 8 | 4.0% |
| o | 7 | 3.5% |
| s | 6 | 3.0% |
| Other values (28) | 58 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 201 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 29 | |
| 28 | ||
| e | 20 | 10.0% |
| r | 15 | 7.5% |
| t | 13 | 6.5% |
| l | 9 | 4.5% |
| j | 8 | 4.0% |
| 0 | 8 | 4.0% |
| o | 7 | 3.5% |
| s | 6 | 3.0% |
| Other values (28) | 58 |
Numero_Reserva
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 10051 |
|---|---|
| Distinct (%) | 96.4% |
| Missing | 5285 |
| Missing (%) | 33.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.6453499 Ă— 109 |
| Minimum | 1.0059188 Ă— 109 |
|---|---|
| Maximum | 5.0001592 Ă— 109 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 122.9 KiB |
Quantile statistics
| Minimum | 1.0059188 Ă— 109 |
|---|---|
| 5-th percentile | 2.2570196 Ă— 109 |
| Q1 | 2.9378111 Ă— 109 |
| median | 3.8202388 Ă— 109 |
| Q3 | 4.2696162 Ă— 109 |
| 95-th percentile | 4.8358709 Ă— 109 |
| Maximum | 5.0001592 Ă— 109 |
| Range | 3.9942404 Ă— 109 |
| Interquartile range (IQR) | 1.3318051 Ă— 109 |
Descriptive statistics
| Standard deviation | 8.2927551 Ă— 108 |
|---|---|
| Coefficient of variation (CV) | 0.22748859 |
| Kurtosis | -0.86882289 |
| Mean | 3.6453499 Ă— 109 |
| Median Absolute Deviation (MAD) | 6.1502163 Ă— 108 |
| Skewness | -0.36088964 |
| Sum | 3.8010064 Ă— 1013 |
| Variance | 6.8769786 Ă— 1017 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4283082648 | 8 | 0.1% |
| 4208534781 | 6 | < 0.1% |
| 4242031213 | 5 | < 0.1% |
| 3234695754 | 5 | < 0.1% |
| 4717565131 | 5 | < 0.1% |
| 4122679904 | 4 | < 0.1% |
| 2944693149 | 4 | < 0.1% |
| 3779868996 | 4 | < 0.1% |
| 4102548481 | 4 | < 0.1% |
| 4273851934 | 4 | < 0.1% |
| Other values (10041) | 10378 | |
| (Missing) | 5285 |
| Value | Count | Frequency (%) |
| 1005918761 | 1 | |
| 1005940672 | 1 | |
| 1007108187 | 1 | |
| 1015466631 | 1 | |
| 1021315351 | 1 | |
| 1021317261 | 1 | |
| 1021389587 | 1 | |
| 1029968432 | 1 | |
| 1062900362 | 1 | |
| 1062942205 | 1 |
| Value | Count | Frequency (%) |
| 5000159195 | 1 | |
| 4999865749 | 1 | |
| 4999810028 | 1 | |
| 4999203753 | 1 | |
| 4999049478 | 1 | |
| 4999029286 | 1 | |
| 4998728654 | 1 | |
| 4998674805 | 1 | |
| 4998670026 | 1 | |
| 4998637580 | 1 |
Mensaje_Huesped
Text
MISSING 
| Distinct | 1184 |
|---|---|
| Distinct (%) | 11.4% |
| Missing | 5293 |
| Missing (%) | 33.7% |
| Memory size | 1.4 MiB |
Length
| Max length | 824 |
|---|---|
| Median length | 0 |
| Mean length | 32.616182 |
| Min length | 0 |
Characters and Unicode
| Total characters | 339828 |
|---|---|
| Distinct characters | 108 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1107 ? |
|---|---|
| Unique (%) | 10.6% |
Sample
| 1st row | |
|---|---|
| 2nd row | |
| 3rd row | |
| 4th row | |
| 5th row |
| Value | Count | Frequency (%) |
| and | 1223 | 3.0% |
| of | 1221 | 3.0% |
| time | 1198 | 2.9% |
| arrival | 1193 | 2.9% |
| between | 1192 | 2.9% |
| approximate | 1188 | 2.9% |
| en | 900 | 2.2% |
| smart | 859 | 2.1% |
| flex | 859 | 2.1% |
| de | 780 | 1.9% |
| Other values (2787) | 30689 |
Most occurring characters
| Value | Count | Frequency (%) |
| 38456 | 11.3% | |
| e | 27544 | 8.1% |
| a | 25766 | 7.6% |
| t | 19390 | 5.7% |
| i | 19317 | 5.7% |
| n | 18796 | 5.5% |
| o | 17847 | 5.3% |
| r | 14641 | 4.3% |
| s | 13779 | 4.1% |
| l | 11445 | 3.4% |
| Other values (98) | 132847 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 339828 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 38456 | 11.3% | |
| e | 27544 | 8.1% |
| a | 25766 | 7.6% |
| t | 19390 | 5.7% |
| i | 19317 | 5.7% |
| n | 18796 | 5.5% |
| o | 17847 | 5.3% |
| r | 14641 | 4.3% |
| s | 13779 | 4.1% |
| l | 11445 | 3.4% |
| Other values (98) | 132847 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 339828 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 38456 | 11.3% | |
| e | 27544 | 8.1% |
| a | 25766 | 7.6% |
| t | 19390 | 5.7% |
| i | 19317 | 5.7% |
| n | 18796 | 5.5% |
| o | 17847 | 5.3% |
| r | 14641 | 4.3% |
| s | 13779 | 4.1% |
| l | 11445 | 3.4% |
| Other values (98) | 132847 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 339828 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 38456 | 11.3% | |
| e | 27544 | 8.1% |
| a | 25766 | 7.6% |
| t | 19390 | 5.7% |
| i | 19317 | 5.7% |
| n | 18796 | 5.5% |
| o | 17847 | 5.3% |
| r | 14641 | 4.3% |
| s | 13779 | 4.1% |
| l | 11445 | 3.4% |
| Other values (98) | 132847 |
BOOKING_NOTE
Text
MISSING 
| Distinct | 2254 |
|---|---|
| Distinct (%) | 21.6% |
| Missing | 5293 |
| Missing (%) | 33.7% |
| Memory size | 1.0 MiB |
Length
| Max length | 30 |
|---|---|
| Median length | 27 |
| Mean length | 27.455226 |
| Min length | 25 |
Characters and Unicode
| Total characters | 286056 |
|---|---|
| Distinct characters | 28 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1051 ? |
|---|---|
| Unique (%) | 10.1% |
Sample
| 1st row | Payment charge is EUR 2.5839 |
|---|---|
| 2nd row | Payment charge is EUR 1.045 |
| 3rd row | Payment charge is EUR 2.695 |
| 4th row | Payment charge is EUR 2.211 |
| 5th row | Payment charge is EUR 2.453 |
| Value | Count | Frequency (%) |
| payment | 10419 | |
| eur | 10419 | |
| charge | 10419 | |
| is | 10419 | |
| 0.715 | 175 | 0.3% |
| 0.781 | 161 | 0.3% |
| 0.649 | 156 | 0.3% |
| 0.5841 | 136 | 0.3% |
| 0.6435 | 121 | 0.2% |
| 0.847 | 118 | 0.2% |
| Other values (2248) | 9552 |
Most occurring characters
| Value | Count | Frequency (%) |
| 41676 | 14.6% | |
| e | 20838 | 7.3% |
| a | 20838 | 7.3% |
| P | 10419 | 3.6% |
| g | 10419 | 3.6% |
| . | 10419 | 3.6% |
| R | 10419 | 3.6% |
| U | 10419 | 3.6% |
| s | 10419 | 3.6% |
| i | 10419 | 3.6% |
| Other values (18) | 129771 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 286056 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 41676 | 14.6% | |
| e | 20838 | 7.3% |
| a | 20838 | 7.3% |
| P | 10419 | 3.6% |
| g | 10419 | 3.6% |
| . | 10419 | 3.6% |
| R | 10419 | 3.6% |
| U | 10419 | 3.6% |
| s | 10419 | 3.6% |
| i | 10419 | 3.6% |
| Other values (18) | 129771 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 286056 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 41676 | 14.6% | |
| e | 20838 | 7.3% |
| a | 20838 | 7.3% |
| P | 10419 | 3.6% |
| g | 10419 | 3.6% |
| . | 10419 | 3.6% |
| R | 10419 | 3.6% |
| U | 10419 | 3.6% |
| s | 10419 | 3.6% |
| i | 10419 | 3.6% |
| Other values (18) | 129771 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 286056 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 41676 | 14.6% | |
| e | 20838 | 7.3% |
| a | 20838 | 7.3% |
| P | 10419 | 3.6% |
| g | 10419 | 3.6% |
| . | 10419 | 3.6% |
| R | 10419 | 3.6% |
| U | 10419 | 3.6% |
| s | 10419 | 3.6% |
| i | 10419 | 3.6% |
| Other values (18) | 129771 |
Numero_Huespedes
Real number (ℝ)
HIGH CORRELATION  ZEROS 
| Distinct | 9 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.5610998 |
| Minimum | 0 |
|---|---|
| Maximum | 8 |
| Zeros | 2442 |
| Zeros (%) | 15.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 122.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 4 |
| 95-th percentile | 6 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 1.7650008 |
|---|---|
| Coefficient of variation (CV) | 0.68915737 |
| Kurtosis | -0.031291712 |
| Mean | 2.5610998 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.45372578 |
| Sum | 40240 |
| Variance | 3.1152278 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 4130 | |
| 4 | 3246 | |
| 0 | 2442 | |
| 3 | 2420 | |
| 1 | 1777 | |
| 5 | 778 | 5.0% |
| 6 | 484 | 3.1% |
| 7 | 315 | 2.0% |
| 8 | 120 | 0.8% |
| Value | Count | Frequency (%) |
| 0 | 2442 | |
| 1 | 1777 | |
| 2 | 4130 | |
| 3 | 2420 | |
| 4 | 3246 | |
| 5 | 778 | 5.0% |
| 6 | 484 | 3.1% |
| 7 | 315 | 2.0% |
| 8 | 120 | 0.8% |
| Value | Count | Frequency (%) |
| 8 | 120 | 0.8% |
| 7 | 315 | 2.0% |
| 6 | 484 | 3.1% |
| 5 | 778 | 5.0% |
| 4 | 3246 | |
| 3 | 2420 | |
| 2 | 4130 | |
| 1 | 1777 | |
| 0 | 2442 |
| Adelanto ya pagado | Adultos | Apartamento | ComisiĂ³n incluida | Estado | Niños | Numero_Huespedes | Numero_Reserva | NĂºmero de noches | Pagado | Pago por adelantado | Portal de reserva | PosiciĂ³n | Precio | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Adelanto ya pagado | 1.000 | 0.024 | 0.059 | 1.000 | 0.000 | 0.000 | 0.024 | 1.000 | 0.000 | 0.024 | 0.707 | 0.054 | 0.034 | 0.000 |
| Adultos | 0.024 | 1.000 | 0.329 | 0.337 | 0.106 | 0.061 | 0.892 | -0.021 | 0.015 | 0.609 | 1.000 | 0.474 | 0.113 | 0.415 |
| Apartamento | 0.059 | 0.329 | 1.000 | 0.074 | 0.071 | 0.111 | 0.375 | 0.000 | 0.078 | 0.284 | 1.000 | 0.395 | 0.196 | 0.083 |
| ComisiĂ³n incluida | 1.000 | 0.337 | 0.074 | 1.000 | 0.069 | 0.175 | 0.416 | -0.010 | 0.738 | 0.026 | 0.000 | 0.023 | 0.050 | 1.000 |
| Estado | 0.000 | 0.106 | 0.071 | 0.069 | 1.000 | 0.006 | 0.104 | 0.120 | 0.019 | 0.125 | 1.000 | 0.130 | 0.031 | 0.062 |
| Niños | 0.000 | 0.061 | 0.111 | 0.175 | 0.006 | 1.000 | 0.467 | -0.008 | 0.024 | 0.182 | 1.000 | 0.122 | 0.053 | 0.196 |
| Numero_Huespedes | 0.024 | 0.892 | 0.375 | 0.416 | 0.104 | 0.467 | 1.000 | -0.026 | 0.024 | 0.610 | 1.000 | 0.473 | 0.118 | 0.475 |
| Numero_Reserva | 1.000 | -0.021 | 0.000 | -0.010 | 0.120 | -0.008 | -0.026 | 1.000 | -0.041 | 0.188 | 0.000 | 1.000 | 0.802 | -0.010 |
| NĂºmero de noches | 0.000 | 0.015 | 0.078 | 0.738 | 0.019 | 0.024 | 0.024 | -0.041 | 1.000 | 0.000 | 1.000 | 0.021 | -0.008 | 0.677 |
| Pagado | 0.024 | 0.609 | 0.284 | 0.026 | 0.125 | 0.182 | 0.610 | 0.188 | 0.000 | 1.000 | 1.000 | 0.732 | 0.482 | 0.036 |
| Pago por adelantado | 0.707 | 1.000 | 1.000 | 0.000 | 1.000 | 1.000 | 1.000 | 0.000 | 1.000 | 1.000 | 1.000 | 1.000 | 0.000 | 0.707 |
| Portal de reserva | 0.054 | 0.474 | 0.395 | 0.023 | 0.130 | 0.122 | 0.473 | 1.000 | 0.021 | 0.732 | 1.000 | 1.000 | 0.150 | 0.035 |
| PosiciĂ³n | 0.034 | 0.113 | 0.196 | 0.050 | 0.031 | 0.053 | 0.118 | 0.802 | -0.008 | 0.482 | 0.000 | 0.150 | 1.000 | 0.066 |
| Precio | 0.000 | 0.415 | 0.083 | 1.000 | 0.062 | 0.196 | 0.475 | -0.010 | 0.677 | 0.036 | 0.707 | 0.035 | 0.066 | 1.000 |
| PosiciĂ³n | Llegada | Salida | Apartamento | HuĂ©sped | Portal de reserva | Creado | TelĂ©fono | DirecciĂ³n | Adultos | Niños | Check-in | Check-out | Notas | Precio | Detalles de precios | ComisiĂ³n incluida | City tax | Pagado | Pago por adelantado | Adelanto ya pagado | NĂºmero de noches | Estado | Nota para colaboradores | Numero_Reserva | Mensaje_Huesped | BOOKING_NOTE | Numero_Huespedes | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 32518147 | 2022-12-31 | 2023-01-01 | HD OLIVIA | NaN | Cerrar fechas (bloqueo) | 2022-12-31 21:56:00 | NaN | NaN | NaN | 0.0 | 0.0 | 2024-08-24 16:00:00 | 2024-08-24 11:00:00 | NaN | NaN | NaN | NaN | NaN | No | NaN | No | 1 | Reservado | NaN | NaN | NaN | NaN | 0.0 |
| 1 | 32518144 | 2022-12-31 | 2023-01-01 | HD FIDEL | NaN | Cerrar fechas (bloqueo) | 2022-12-31 21:56:00 | NaN | NaN | NaN | 0.0 | 0.0 | 2024-08-24 16:00:00 | 2024-08-24 11:00:00 | NaN | NaN | NaN | NaN | NaN | No | NaN | No | 1 | Reservado | NaN | NaN | NaN | NaN | 0.0 |
| 2 | 32518120 | 2022-12-31 | 2023-01-01 | HD ALEJANDRA | NaN | Cerrar fechas (bloqueo) | 2022-12-31 21:56:00 | NaN | NaN | NaN | 0.0 | 0.0 | 2024-08-24 16:00:00 | 2024-08-24 11:00:00 | NaN | NaN | NaN | NaN | NaN | No | NaN | No | 1 | Reservado | NaN | NaN | NaN | NaN | 0.0 |
| 3 | 32518117 | 2022-12-31 | 2023-01-01 | H BMA LISBOA | NaN | Cerrar fechas (bloqueo) | 2022-12-31 21:55:00 | NaN | NaN | NaN | 0.0 | 0.0 | NaT | NaT | NaN | NaN | NaN | NaN | NaN | No | NaN | No | 1 | Reservado | NaN | NaN | NaN | NaN | 0.0 |
| 4 | 32489530 | 2022-12-30 | 2022-12-31 | HD OLIVIA | NaN | Cerrar fechas (bloqueo) | 2022-12-30 22:03:00 | NaN | NaN | NaN | 0.0 | 0.0 | 2024-08-24 16:00:00 | 2024-08-24 11:00:00 | NaN | NaN | NaN | NaN | NaN | No | NaN | No | 1 | Reservado | NaN | NaN | NaN | NaN | 0.0 |
| 5 | 32489521 | 2022-12-30 | 2022-12-31 | HD HUGHET | NaN | Cerrar fechas (bloqueo) | 2022-12-30 22:02:00 | NaN | NaN | NaN | 0.0 | 0.0 | 2024-08-24 16:00:00 | 2024-08-24 11:00:00 | NaN | NaN | NaN | NaN | NaN | No | NaN | No | 1 | Reservado | NaN | NaN | NaN | NaN | 0.0 |
| 6 | 32489518 | 2022-12-30 | 2022-12-31 | HD GLORIA | NaN | Cerrar fechas (bloqueo) | 2022-12-30 22:02:00 | NaN | NaN | NaN | 0.0 | 0.0 | 2024-08-24 16:00:00 | 2024-08-24 11:00:00 | NaN | NaN | NaN | NaN | NaN | No | NaN | No | 1 | Reservado | NaN | NaN | NaN | NaN | 0.0 |
| 7 | 32489503 | 2022-12-30 | 2022-12-31 | HD FIDEL | NaN | Cerrar fechas (bloqueo) | 2022-12-30 22:02:00 | NaN | NaN | NaN | 0.0 | 0.0 | 2024-08-24 16:00:00 | 2024-08-24 11:00:00 | NaN | NaN | NaN | NaN | NaN | No | NaN | No | 1 | Reservado | NaN | NaN | NaN | NaN | 0.0 |
| 8 | 32489473 | 2022-12-30 | 2022-12-31 | HD DARIO | NaN | Cerrar fechas (bloqueo) | 2022-12-30 22:01:00 | NaN | NaN | NaN | 0.0 | 0.0 | 2024-08-24 16:00:00 | 2024-08-24 11:00:00 | NaN | NaN | NaN | NaN | NaN | No | NaN | No | 1 | Reservado | NaN | NaN | NaN | NaN | 0.0 |
| 9 | 32489449 | 2022-12-30 | 2022-12-31 | HD CELESTE | NaN | Cerrar fechas (bloqueo) | 2022-12-30 22:00:00 | NaN | NaN | NaN | 0.0 | 0.0 | 2024-08-24 16:00:00 | 2024-08-24 11:00:00 | NaN | NaN | NaN | NaN | NaN | No | NaN | No | 1 | Reservado | NaN | NaN | NaN | NaN | 0.0 |
| PosiciĂ³n | Llegada | Salida | Apartamento | HuĂ©sped | Portal de reserva | Creado | TelĂ©fono | DirecciĂ³n | Adultos | Niños | Check-in | Check-out | Notas | Precio | Detalles de precios | ComisiĂ³n incluida | City tax | Pagado | Pago por adelantado | Adelanto ya pagado | NĂºmero de noches | Estado | Nota para colaboradores | Numero_Reserva | Mensaje_Huesped | BOOKING_NOTE | Numero_Huespedes | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15702 | 49003082 | 2023-12-26 | 2024-05-01 | HD BRUNO | Cristina Maldonado | Booking.com | 2023-12-11 23:56:00 | cmaldo.123819@guest.booking.com | +34 648 11 83 53 | NaN | 2.0 | 1.0 | 2024-08-24 16:00:00 | 2024-08-24 11:00:00 | NĂºmero de reserva: 4002704862\nMensaje del huĂ©sped: ** THIS RESERVATION HAS BEEN PRE-PAID ** BOOKING NOTE : Payment charge is EUR 13.98782\n\nDirecciĂ³n: Gh\nES\nMĂ¡s informaciĂ³n: booker_is_genius\nPago por adelantado: 1271.62EUR | 1271.62 | IVA - EUR 115.6 | 190.74 | NaN | SĂ | NaN | No | 10 | Reservado | NaN | 4002704862 | Payment charge is EUR 13.98782 | 3.0 | |
| 15703 | 48800213 | 2024-03-02 | 2024-05-02 | H BMA AMSTERDAM | Noemi Espinosa | Booking.com | 2023-08-11 16:16:00 | nespin.215286@guest.booking.com | +44 7426761457 | NaN | 6.0 | 2.0 | 2024-08-24 16:00:00 | 2024-08-24 11:00:00 | NĂºmero de reserva: 4202562635\nMensaje del huĂ©sped: ** THIS RESERVATION HAS BEEN PRE-PAID ** BOOKING NOTE : Payment charge is EUR 6.0335\n\nMĂ¡s informaciĂ³n: booker_is_genius\nPago por adelantado: 548.50EUR | 548.50 | TVA - EUR 49.86 | 82.28 | NaN | SĂ | NaN | No | 2 | Cancelado | NaN | 4202562635 | Payment charge is EUR 6.0335 | 8.0 | |
| 15704 | 48681794 | 2024-01-26 | 2024-01-28 | H BMA BERLIN | Alicia Solis Picatto | Booking.com | 2023-06-11 12:50:00 | apicat.578133@guest.booking.com | +34 684 62 58 24 | NaN | 6.0 | 0.0 | 2024-08-24 16:00:00 | 2024-08-24 11:00:00 | NĂºmero de reserva: 4128424493\nMensaje del huĂ©sped: ** THIS RESERVATION HAS BEEN PRE-PAID ** BOOKING NOTE : Payment charge is EUR 5.104\n\nDirecciĂ³n: Arturo Alvarez Buylla n4 6B\nOviedo\nES\nMĂ¡s informaciĂ³n: booker_is_genius\nPago por adelantado: 464.00EUR | 464.00 | TVA - EUR 42.18 | 69.60 | NaN | SĂ | NaN | No | 2 | Reservado | NaN | 4128424493 | Payment charge is EUR 5.104 | 6.0 | |
| 15705 | 48218090 | 2024-02-25 | 2024-02-26 | H BMA MONACO | JosĂ© luis ruiz martinez | Booking.com | 2023-10-27 14:42:00 | ndqjfx.980350@guest.booking.com | +34 627 23 87 92 | NaN | 2.0 | 2.0 | NaT | NaT | NĂºmero de reserva: 4254973846\nMensaje del huĂ©sped: ** THIS RESERVATION HAS BEEN PRE-PAID ** BOOKING NOTE : Payment charge is EUR 0.891 Approximate time of arrival: between 11:00 and 12:00\n\nMĂ¡s informaciĂ³n: booker_is_genius\nPago por adelantado: 81.00EUR | 81.00 | TVA - EUR 7.36 | 12.15 | NaN | SĂ | NaN | No | 1 | Reservado | NaN | 4254973846 | Approximate time of arrival: between 11:00 and 12:00 | Payment charge is EUR 0.891 | 4.0 |
| 15706 | 48179030 | 2024-01-22 | 2024-01-24 | HG1 ARTXANDA | Jorge Rubio Alcaraz | Airbnb | 2023-10-26 18:05:00 | NaN | 34666007165 | NaN | 7.0 | 0.0 | 2024-08-24 16:00:00 | 2024-08-24 11:00:00 | NĂºmero de reserva: HME2B4WMFN\nIdioma del huĂ©sped: es | 327.80 | Cancellation Host Fee - EUR 44.7\nCancellation Payout - EUR 283.1 | 44.70 | NaN | No | NaN | No | 2 | Cancelado | NaN | NaN | NaN | NaN | 7.0 |
| 15707 | 48020365 | 2024-06-17 | 2024-06-21 | H - BUA 3P | Navarra Adentro | Reserva directa | 2023-10-23 12:17:00 | NaN | 659636268 | NaN | 1.0 | 0.0 | 2024-08-24 16:00:00 | 2024-08-24 11:00:00 | Viene con un grupo del hostel. | 520.00 | NaN | NaN | NaN | No | NaN | No | 4 | Reservado | NaN | NaN | NaN | NaN | 1.0 |
| 15708 | 46670629 | 2024-11-02 | 2024-12-02 | H BMA AMSTERDAM | Crespi Catalina | Booking.com | 2023-09-26 14:51:00 | ccatal.288618@guest.booking.com | +34 617 49 18 56 | NaN | 7.0 | 0.0 | 2024-08-24 16:00:00 | 2024-08-24 11:00:00 | NĂºmero de reserva: 4232587055\nMensaje del huĂ©sped: ** THIS RESERVATION HAS BEEN PRE-PAID ** BOOKING NOTE : Payment charge is EUR 1.75175\n\nMĂ¡s informaciĂ³n: booker_is_genius\nPago por adelantado: 159.25EUR | 159.25 | TVA - EUR 14.48 | 23.89 | NaN | SĂ | NaN | No | 1 | Cancelado | NaN | 4232587055 | Payment charge is EUR 1.75175 | 7.0 | |
| 15709 | 46642321 | 2024-12-01 | 2024-01-14 | H BMA BERLIN | Mikel Zugasti Rezola | Booking.com | 2023-09-25 23:26:00 | mrezol.585471@guest.booking.com | +34 666 22 54 76 | NaN | 6.0 | 0.0 | 2024-08-24 16:00:00 | 2024-08-24 11:00:00 | NĂºmero de reserva: 4237415932\nMensaje del huĂ©sped: ** THIS RESERVATION HAS BEEN PRE-PAID ** Approximate time of arrival: between 17:00 and 18:00 BOOKING NOTE : Payment charge is EUR 13.1274\n\nMĂ¡s informaciĂ³n: booker_is_genius\nPago por adelantado: 1193.40EUR | 521.60 | TVA - EUR 47.42 | 78.24 | NaN | SĂ | NaN | No | 2 | Cancelado | NaN | 4237415932 | Payment charge is EUR 13.1274 | 6.0 | |
| 15710 | 46642318 | 2024-12-01 | 2024-01-14 | H BMA AMSTERDAM | Mikel Zugasti Rezola | Booking.com | 2023-09-25 23:26:00 | mrezol.585471@guest.booking.com | +34 666 22 54 76 | NaN | 5.0 | 0.0 | 2024-08-24 16:00:00 | 2024-08-24 11:00:00 | NĂºmero de reserva: 4237415932\nMensaje del huĂ©sped: ** THIS RESERVATION HAS BEEN PRE-PAID ** Approximate time of arrival: between 17:00 and 18:00 BOOKING NOTE : Payment charge is EUR 13.1274\n\nMĂ¡s informaciĂ³n: booker_is_genius\nPago por adelantado: 1193.40EUR | 671.80 | TVA - EUR 61.07 | 100.77 | NaN | SĂ | NaN | No | 2 | Cancelado | NaN | 4237415932 | Payment charge is EUR 13.1274 | 5.0 | |
| 15711 | 45005552 | 2024-08-01 | 2024-10-01 | HG0 MUGARRA | Roxana Palala MĂ©ndez | Airbnb | 2023-08-26 11:09:00 | NaN | 50255354808 | NaN | 7.0 | 0.0 | 2024-08-24 16:00:00 | 2024-08-24 11:00:00 | NĂºmero de reserva: HM9ENYC99S\nIdioma del huĂ©sped: en | 261.80 | Cancellation Host Fee - EUR 35.7\nCancellation Payout - EUR 226.1 | 35.70 | NaN | SĂ | NaN | No | 2 | Reservado | NaN | NaN | NaN | NaN | 7.0 |
Most frequently occurring
| PosiciĂ³n | Llegada | Salida | Apartamento | HuĂ©sped | Portal de reserva | Creado | TelĂ©fono | Adultos | Niños | Check-in | Check-out | Notas | Precio | Detalles de precios | ComisiĂ³n incluida | Pagado | Pago por adelantado | Adelanto ya pagado | NĂºmero de noches | Estado | Nota para colaboradores | Numero_Reserva | Mensaje_Huesped | BOOKING_NOTE | Numero_Huespedes | # duplicates | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 29995319 | 2022-12-29 | 2023-05-01 | H BMA OSLO | Johannes Schmid | Airbnb | 2022-10-22 16:02:00 | NaN | 491703538486 | 2.0 | 0.0 | NaT | NaT | NĂºmero de reserva: HMDEHF2TH3\nIdioma del huĂ©sped: de | 1021.90 | Cancellation Host Fee - EUR 153.29\nCancellation Payout - EUR 868.61\nSecurity Price - EUR 1500 | 153.29 | SĂ | NaN | No | 7 | Reservado | NaN | NaN | NaN | NaN | 2.0 | 2 |
| 1 | 31968127 | 2022-12-28 | 2023-07-01 | H BMA DUBLIN | NaN | Cerrar fechas (bloqueo) | 2022-12-15 12:46:00 | NaN | NaN | 0.0 | 0.0 | NaT | NaT | NaN | NaN | NaN | NaN | No | NaN | No | 10 | Cancelado | NaN | NaN | NaN | NaN | 0.0 | 2 |
| 2 | 32169718 | 2022-12-30 | 2023-05-01 | H - BUA 4P | NaN | Cerrar fechas (bloqueo) | 2022-12-21 12:07:00 | NaN | NaN | 0.0 | 0.0 | 2024-08-24 16:00:00 | 2024-08-24 11:00:00 | NaN | NaN | NaN | NaN | No | NaN | No | 6 | Reservado | NaN | NaN | NaN | NaN | 0.0 | 2 |
| 3 | 32469028 | 2022-12-31 | 2023-04-01 | H BMA GARAJE | luis | Reserva directa | 2022-12-30 12:50:00 | NaN | NaN | 0.0 | 0.0 | NaT | NaT | NaN | NaN | NaN | NaN | No | NaN | No | 4 | Reservado | NaN | NaN | NaN | NaN | 0.0 | 2 |
| 4 | 33796325 | 2023-02-24 | 2023-02-26 | H BMA MONACO | Sara Rodriguez Carvalho | Booking.com | 2023-01-25 00:44:00 | scarva.107440@guest.booking.com | +351 964 835 713 | 4.0 | 0.0 | NaT | NaT | NĂºmero de reserva: 3930128015\nMensaje del huĂ©sped: ** THIS RESERVATION HAS BEEN PRE-PAID ** BOOKING NOTE : Payment charge is EUR 6.523 Approximate time of arrival: between 00:00 and 01:00 the next day\n\nMĂ¡s informaciĂ³n: booker_is_genius\nPago por adelantado: 593.00EUR | 265.00 | TVA - EUR 24.09 | 39.75 | SĂ | NaN | No | 2 | Reservado | NaN | 3930128015 | Approximate time of arrival: between 00:00 and 01:00 the next day | Payment charge is EUR 6.523 | 4.0 | 2 |
| 5 | 38091838 | 2023-05-20 | 2023-05-21 | HD ELENA | Marina Losa Picornell | Booking.com | 2023-04-16 22:19:00 | jgarau.803545@guest.booking.com | +34 675 15 42 85 | 6.0 | 0.0 | 2024-08-24 16:00:00 | 2024-08-24 11:00:00 | NĂºmero de reserva: 2795551840\nMensaje del huĂ©sped: ** THIS RESERVATION HAS BEEN PRE-PAID ** BOOKING NOTE : Payment charge is EUR 4.99895\n\nMĂ¡s informaciĂ³n: booker_is_genius\nPago por adelantado: 454.45EUR | 257.35 | IVA - EUR 23.4 | 38.60 | SĂ | NaN | No | 1 | Cancelado | NaN | 2795551840 | Payment charge is EUR 4.99895 | 6.0 | 2 | |
| 6 | 49003082 | 2023-12-26 | 2024-05-01 | HD BRUNO | Cristina Maldonado | Booking.com | 2023-12-11 23:56:00 | cmaldo.123819@guest.booking.com | +34 648 11 83 53 | 2.0 | 1.0 | 2024-08-24 16:00:00 | 2024-08-24 11:00:00 | NĂºmero de reserva: 4002704862\nMensaje del huĂ©sped: ** THIS RESERVATION HAS BEEN PRE-PAID ** BOOKING NOTE : Payment charge is EUR 13.98782\n\nDirecciĂ³n: Gh\nES\nMĂ¡s informaciĂ³n: booker_is_genius\nPago por adelantado: 1271.62EUR | 1271.62 | IVA - EUR 115.6 | 190.74 | SĂ | NaN | No | 10 | Reservado | NaN | 4002704862 | Payment charge is EUR 13.98782 | 3.0 | 2 | |
| 7 | 49082867 | 2023-12-26 | 2024-05-01 | HD-GARAJE 5 | bruno | Reserva directa | 2023-11-14 14:49:00 | NaN | NaN | 0.0 | 0.0 | NaT | NaT | tarjeta el 14-11 | 200.00 | NaN | NaN | No | NaN | No | 10 | Reservado | NaN | NaN | NaN | NaN | 0.0 | 2 |
| 8 | 49378100 | 2023-12-31 | 2024-02-01 | HD ELENA | Llorian Alvarez Martinez | Airbnb | 2023-11-20 20:28:00 | NaN | 34644263765 | 6.0 | 0.0 | 2024-08-24 16:00:00 | 2024-08-24 11:00:00 | NĂºmero de reserva: HMAYKBSY9W\nIdioma del huĂ©sped: es | 571.00 | Cancellation Host Fee - EUR 85.65\nCancellation Payout - EUR 485.35\nSecurity Price - EUR 1500 | 85.65 | SĂ | NaN | No | 2 | Reservado | NaN | NaN | NaN | NaN | 6.0 | 2 |
| 9 | 49787999 | 2023-05-12 | 2024-05-02 | HD ALEJANDRA | Shirly a confirmar | Reserva directa | 2023-11-29 16:26:00 | NaN | NaN | 0.0 | 0.0 | 2024-08-24 16:00:00 | 2024-08-24 11:00:00 | NaN | 7847.60 | NaN | NaN | No | NaN | No | 62 | Cancelado | NaN | NaN | NaN | NaN | 0.0 | 2 |